/*******************************************************************************

This code file cleans 421a type as scraped from assessment records.

*******************************************************************************/

*** Manage settings

	run "~/Dropbox (MIT)/Research/NYC421a/code/modules/settings.do"
	
*** Import data
	
	* Import file of all BBLs w/ new construction in 2003-2015
	import delimited "$data/raw/pdfs/scrape_not.csv", encoding(ISO-8859-1) clear
	
	tempfile tmp
	save `tmp', replace
		
	* Reformat BBLs
	format bbl %18.0f	
	
	collapse (max) flag*, by(bbl)
	
*** Save data

	save "$data/clean/assessments_cleaned.dta", replace
